Fuzzy to SQL Conversion using Gefred Model with the help of MATLAB
نویسندگان
چکیده
For Many Years, achieving unambiguous knowledge has been turned to a serious challenge for human being. The aim of this paper is to emphasize situation when classical {true, false} logic is not adequate for data selection and data classification. Linguistic expression like: high salary, young etc are very often used in life and in statistics. The goal of this paper is brief study of fuzzy logic and sets and how to make it suitable for database queries and classification tasks. Fuzzy approach is introduced with usual relational database model to handle linguistic queries. The purposed fuzzy approach provides flexibility when users cannot unambiguously set hidden boundaries between data. Our work gives the flexibility to query the database in natural language using FRDB, which permits to have a range of answers in order to offer to the user all intermediate variations, which in turn will enhance the expressiveness of human expression, without any effect on searching time and with reduced cost. In this paper we are using Query Builder tool of MATLAB to show the result of query. Fuzzy query interpreter helps to convert fuzzy query into SQL query without need to learn a new query language. In this paper, we extend the work of medina et al. to implement a new architecture of fuzzy DBMS based on the GEFRED model. This architecture is based on the concept of weak coupling with the DBMS SQL Server.
منابع مشابه
Fuzzy to SQL Conversion using Gefred Model with the help of MATLAB
For Many Years, achieving unambiguous knowledge has been turned to a serious challenge for human being. The aim of this paper is to emphasize situation when classical {true, false} logic is not adequate for data selection and data classification. Linguistic expression like: high salary, young etc are very often used in life and in statistics. The goal of this paper is brief study of fuzzy logic...
متن کاملNew architecture of fuzzy database management systems
Fuzzy relational data bases have been extensively studied in a theoretical level. Unfortunately, the repercussions of these works on the practical plan are negligible. Medina et al. have developed a server named fuzzy SQL, supporting flexible queries and based on a theoretic model called GEFRED. This server has been programmed in PL/SQL language under Oracle database management systems. To mode...
متن کاملConversion of Fuzzy Query into SQL Query
Traditional database systems can deal with perfect data. But lot of information is present in imperfect form due to vagueness or imprecision. [16] Fuzzy set theory has been applied to deal with imperfections of data and to enhance the accessibility of databases. When users work with usual software tools they have to change their many valued logical thinking (approximate reasoning) into the twov...
متن کاملDeduction in a GEFRED database using Datalog
In this paper, some considerations on extension of the Datalog language are proposed in order to apply this language on a GEFRED fuzzy relational database. For this integration, we use some extended comparators from the GEFRED model and an existing generalization of the concept of rule to work with flexible values.
متن کاملA New Approach to Solve Fully Fuzzy Linear Programming with Trapezoidal Numbers Using Conversion Functions
Recently, fuzzy linear programming problems have been considered by many. In the literature of fuzzy linear programming several models are offered and therefore some various methods have been suggested to solve these problems. One of the most important of these problems that recently has been considered; are Fully Fuzzy Linear Programming (FFLP), which all coefficients and variables of the prob...
متن کامل